Foreign key fields (i.e. The key that represents the value of a primary key in a related table) may exist in the case of CLEBSI speciment: date of diagnosis, date and time of specimen (where latter may replicate). Under 'Patient', CLEBSI line is a foreign key, too.

V. Atomic-level data

Atomic data would be the most reducible element of information (without elaboration). So for instance for hand hygiene it would be Chlorhexidine Skin Antisepsis Antimicrobial Dressing Placement

VI. Schemas of the database will be:

Patient with the attributes of name, age, medical record number (MRN), diagnosis, central line; Central line with the attributes of medical record number, date of insertion, insertion site, date of removal, line days, inserting provider, the components Central Line Bundle compliance, antimicrobial dressing placement; and CLABSI infections with attributes of MRN, date of diagnosis, date and time of specimen, organism detected. Central Line Bundle compliance will be measured by the evidence-based standards determined by the Institute for Healthcare Improvement (IHI, n.d).

In short, the data will be organized in the following way:

Patient, Central Line, CLABSI Infection will be the field names. The primary key of the Patient table will be the MRN, of the Central Line Table - the Insertion site, and of CLABSI infection -MRN.

Their attributes will be the 'master keys' with the relevant information (i.e., the details) being the 'order' keys. These 'order' keys...

For presentation of these order keys see above under field types.
The entire assignment was somewhat complex, but once I had an idea of the requirements of CLABSI, and reformulated some of the information I was able to get past the roadblocks. One challenge, for instance, was determining the primary keys for Central Line and CLABSI since the central line by the former can by definition exist of more than one, and even more than one on the same day. I, therefore, transferred primary key to Insertion site. By CLABSI, I left MRN as primary key since we are focusing on the Primary Blood Stream Infection (BSI) and it is this that health-care institutions use to record presence of CLABSI (CDC, 2010)

Reference

CDC (2010) Central Line-Associated Bloodstream Infection (CLABSI) Event. Retrieved April 1, 2011 from www.cdc.gov/nhsn/PDFs/pscManual/4PSC_CLABScurrent.pdf

Databasics: A Database Dictionary. Retrieved April 1, 2011 from: http://www.geekgirls.com/database_dictionary.htm

Institute for Healthcare Improvement. (n.d.). Implement the central line bundle. Retrieved March 21, 2011, from http://www.ihi.org/IHI/Topics/CriticalCare/IntensiveCare/Changes/ImplementtheCentralLineBundle.htm

Moodle. Database Fields. Retrieved April 1, 2011 from http://docs.moodle.org/en/Database_fields#Field_name_and_description

Walkthrough: Creating a Master / Detail. Retrieved April 1, 2011 from http://msdn.microsoft.com/en-us/library/y8c0cxey.aspx